<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />
<title>DataBaseQueryCreator xref</title>
<link type="text/css" rel="stylesheet" href="../../../../../stylesheet.css" />
</head>
<body>
<div id="overview"><a href="../../../../../../apidocs/org/commons/database/util/jquerycreator/DataBaseQueryCreator.html">View Javadoc</a></div><pre>

<a name="1" href="#1">1</a>   <em class="jxr_javadoccomment">/**</em>
<a name="2" href="#2">2</a>   <em class="jxr_javadoccomment"> * </em>
<a name="3" href="#3">3</a>   <em class="jxr_javadoccomment"> * Copyright 2009 Marco Speranza &lt;marco.speranza79@gmail.com&gt;</em>
<a name="4" href="#4">4</a>   <em class="jxr_javadoccomment"> *    </em>
<a name="5" href="#5">5</a>   <em class="jxr_javadoccomment"> * Licensed under the Apache License, Version 2.0 (the "License");</em>
<a name="6" href="#6">6</a>   <em class="jxr_javadoccomment"> * you may not use this file except in compliance with the License.</em>
<a name="7" href="#7">7</a>   <em class="jxr_javadoccomment"> * You may obtain a copy of the License at</em>
<a name="8" href="#8">8</a>   <em class="jxr_javadoccomment"> *   </em>
<a name="9" href="#9">9</a>   <em class="jxr_javadoccomment"> * <a href="http://www.apache.org/licenses/LICENSE-2.0" target="alexandria_uri">http://www.apache.org/licenses/LICENSE-2.0</a></em>
<a name="10" href="#10">10</a>  <em class="jxr_javadoccomment"> *  </em>
<a name="11" href="#11">11</a>  <em class="jxr_javadoccomment"> * Unless required by applicable law or agreed to in writing, software</em>
<a name="12" href="#12">12</a>  <em class="jxr_javadoccomment"> * distributed under the License is distributed on an "AS IS" BASIS,</em>
<a name="13" href="#13">13</a>  <em class="jxr_javadoccomment"> * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.</em>
<a name="14" href="#14">14</a>  <em class="jxr_javadoccomment"> * See the License for the specific language governing permissions and</em>
<a name="15" href="#15">15</a>  <em class="jxr_javadoccomment"> * limitations under the License.</em>
<a name="16" href="#16">16</a>  <em class="jxr_javadoccomment"> */</em>
<a name="17" href="#17">17</a>  
<a name="18" href="#18">18</a>  <strong class="jxr_keyword">package</strong> org.commons.database.util.jquerycreator;
<a name="19" href="#19">19</a>  
<a name="20" href="#20">20</a>  <strong class="jxr_keyword">import</strong> java.io.ByteArrayInputStream;
<a name="21" href="#21">21</a>  <strong class="jxr_keyword">import</strong> java.io.InputStream;
<a name="22" href="#22">22</a>  <strong class="jxr_keyword">import</strong> java.sql.Blob;
<a name="23" href="#23">23</a>  <strong class="jxr_keyword">import</strong> java.sql.Clob;
<a name="24" href="#24">24</a>  <strong class="jxr_keyword">import</strong> java.sql.Connection;
<a name="25" href="#25">25</a>  <strong class="jxr_keyword">import</strong> java.sql.PreparedStatement;
<a name="26" href="#26">26</a>  <strong class="jxr_keyword">import</strong> java.sql.ResultSet;
<a name="27" href="#27">27</a>  <strong class="jxr_keyword">import</strong> java.sql.SQLException;
<a name="28" href="#28">28</a>  <strong class="jxr_keyword">import</strong> java.sql.Statement;
<a name="29" href="#29">29</a>  <strong class="jxr_keyword">import</strong> java.sql.Timestamp;
<a name="30" href="#30">30</a>  <strong class="jxr_keyword">import</strong> java.sql.Types;
<a name="31" href="#31">31</a>  <strong class="jxr_keyword">import</strong> java.util.HashMap;
<a name="32" href="#32">32</a>  <strong class="jxr_keyword">import</strong> java.util.Map;
<a name="33" href="#33">33</a>  <strong class="jxr_keyword">import</strong> java.util.regex.Matcher;
<a name="34" href="#34">34</a>  <strong class="jxr_keyword">import</strong> java.util.regex.Pattern;
<a name="35" href="#35">35</a>  
<a name="36" href="#36">36</a>  <strong class="jxr_keyword">import</strong> org.apache.commons.logging.Log;
<a name="37" href="#37">37</a>  <strong class="jxr_keyword">import</strong> org.apache.commons.logging.LogFactory;
<a name="38" href="#38">38</a>  <strong class="jxr_keyword">import</strong> org.commons.util.conversion.DateConv;
<a name="39" href="#39">39</a>  
<a name="40" href="#40">40</a>  <em class="jxr_comment">// TODO: Auto-generated Javadoc</em>
<a name="41" href="#41">41</a>  <em class="jxr_javadoccomment">/**</em>
<a name="42" href="#42">42</a>  <em class="jxr_javadoccomment"> * Classe per la creazione delle query sql. Questa classe non e' sincronizzata.</em>
<a name="43" href="#43">43</a>  <em class="jxr_javadoccomment"> * In ambiente multithreading utilizzare</em>
<a name="44" href="#44">44</a>  <em class="jxr_javadoccomment"> * &lt;code&gt; SyncronizedDataBaseQueryCreator &lt;/code&gt;</em>
<a name="45" href="#45">45</a>  <em class="jxr_javadoccomment"> * </em>
<a name="46" href="#46">46</a>  <em class="jxr_javadoccomment"> * Ogni metodo che lancia una SQLException chude tutte le risorse eventualmente</em>
<a name="47" href="#47">47</a>  <em class="jxr_javadoccomment"> * aperte al datasource in caso di SQLException.</em>
<a name="48" href="#48">48</a>  <em class="jxr_javadoccomment"> * </em>
<a name="49" href="#49">49</a>  <em class="jxr_javadoccomment"> * un tipico uso e':</em>
<a name="50" href="#50">50</a>  <em class="jxr_javadoccomment"> * </em>
<a name="51" href="#51">51</a>  <em class="jxr_javadoccomment"> * &lt;pre&gt;</em>
<a name="52" href="#52">52</a>  <em class="jxr_javadoccomment"> * dbqc = new DataBaseQueryCreator();</em>
<a name="53" href="#53">53</a>  <em class="jxr_javadoccomment"> * dbqc.setDataSourceManager(datasourceManager); // e' una implementazione dell'interfaccia IDatasourceManager</em>
<a name="54" href="#54">54</a>  <em class="jxr_javadoccomment"> * dbqc.setSql(&amp;quot;SELECT id, testblob FROM test where id =?&amp;quot;);</em>
<a name="55" href="#55">55</a>  <em class="jxr_javadoccomment"> * dbqc.put(&amp;quot;pippo&amp;quot;, Types.VARCHAR);</em>
<a name="56" href="#56">56</a>  <em class="jxr_javadoccomment"> * try {</em>
<a name="57" href="#57">57</a>  <em class="jxr_javadoccomment"> *     dbqc.fillQuery();</em>
<a name="58" href="#58">58</a>  <em class="jxr_javadoccomment"> *     dbqc.executeQuery();</em>
<a name="59" href="#59">59</a>  <em class="jxr_javadoccomment"> *     ResultSet tupla = dbqc.getResultSet();</em>
<a name="60" href="#60">60</a>  <em class="jxr_javadoccomment"> *     while (tupla.next()) {</em>
<a name="61" href="#61">61</a>  <em class="jxr_javadoccomment"> * 	int id = tupla.getInt(&amp;quot;id&amp;quot;);</em>
<a name="62" href="#62">62</a>  <em class="jxr_javadoccomment"> * 	Blob b = tupla.getBlob(&amp;quot;testblob&amp;quot;);</em>
<a name="63" href="#63">63</a>  <em class="jxr_javadoccomment"> *     }</em>
<a name="64" href="#64">64</a>  <em class="jxr_javadoccomment"> * } catch (SQLException e) {</em>
<a name="65" href="#65">65</a>  <em class="jxr_javadoccomment"> *     e.printStackTrace();</em>
<a name="66" href="#66">66</a>  <em class="jxr_javadoccomment"> *     System.err.println(e.getMessage());</em>
<a name="67" href="#67">67</a>  <em class="jxr_javadoccomment"> * } finally {</em>
<a name="68" href="#68">68</a>  <em class="jxr_javadoccomment"> *     dbqc.closeAll();</em>
<a name="69" href="#69">69</a>  <em class="jxr_javadoccomment"> * }</em>
<a name="70" href="#70">70</a>  <em class="jxr_javadoccomment"> * &lt;/pre&gt;</em>
<a name="71" href="#71">71</a>  <em class="jxr_javadoccomment"> * </em>
<a name="72" href="#72">72</a>  <em class="jxr_javadoccomment"> * oppure:</em>
<a name="73" href="#73">73</a>  <em class="jxr_javadoccomment"> * </em>
<a name="74" href="#74">74</a>  <em class="jxr_javadoccomment"> * &lt;pre&gt;</em>
<a name="75" href="#75">75</a>  <em class="jxr_javadoccomment"> * dbqc = new DataBaseQueryCreator();</em>
<a name="76" href="#76">76</a>  <em class="jxr_javadoccomment"> * dbqc.setDataSourceManager(datasourceManager); // e' una implementazione dell'interfaccia IDatasourceManager</em>
<a name="77" href="#77">77</a>  <em class="jxr_javadoccomment"> * dbqc.setSql(&amp;quot;SELECT id, testblob FROM test where id =?&amp;quot; FOR UPDATE);</em>
<a name="78" href="#78">78</a>  <em class="jxr_javadoccomment"> * dbqc.put(&amp;quot;pippo&amp;quot;, Types.VARCHAR);</em>
<a name="79" href="#79">79</a>  <em class="jxr_javadoccomment"> * try {</em>
<a name="80" href="#80">80</a>  <em class="jxr_javadoccomment"> *     dbqc.fillQuery();</em>
<a name="81" href="#81">81</a>  <em class="jxr_javadoccomment"> *     dbqc.executeQuery();</em>
<a name="82" href="#82">82</a>  <em class="jxr_javadoccomment"> *     ResultSet tupla = dbqc.getResultSet();</em>
<a name="83" href="#83">83</a>  <em class="jxr_javadoccomment"> *     while (tupla.next()) {</em>
<a name="84" href="#84">84</a>  <em class="jxr_javadoccomment"> * 	int id = tupla.getInt(&amp;quot;id&amp;quot;);</em>
<a name="85" href="#85">85</a>  <em class="jxr_javadoccomment"> * 	Blob b = tupla.getBlob(&amp;quot;testblob&amp;quot;);</em>
<a name="86" href="#86">86</a>  <em class="jxr_javadoccomment"> *     }</em>
<a name="87" href="#87">87</a>  <em class="jxr_javadoccomment"> * } catch (SQLException e) {</em>
<a name="88" href="#88">88</a>  <em class="jxr_javadoccomment"> *     e.printStackTrace();</em>
<a name="89" href="#89">89</a>  <em class="jxr_javadoccomment"> *     System.err.println(e.getMessage());</em>
<a name="90" href="#90">90</a>  <em class="jxr_javadoccomment"> *     dbqc.closeAll();</em>
<a name="91" href="#91">91</a>  <em class="jxr_javadoccomment"> * } finally {</em>
<a name="92" href="#92">92</a>  <em class="jxr_javadoccomment"> *     dbqc.closeAllWithoutConnection();  //vengono chiuse tutte le risorse ECCETTO la connessione.</em>
<a name="93" href="#93">93</a>  <em class="jxr_javadoccomment"> * }</em>
<a name="94" href="#94">94</a>  <em class="jxr_javadoccomment"> * </em>
<a name="95" href="#95">95</a>  <em class="jxr_javadoccomment"> * dbqc.clear();</em>
<a name="96" href="#96">96</a>  <em class="jxr_javadoccomment"> * dbqc.setSql(&amp;quot;UPDATE test set id = ? where id =?&amp;quot;);</em>
<a name="97" href="#97">97</a>  <em class="jxr_javadoccomment"> * dbqc.put(&amp;quot;pluto&amp;quot;, Types.VARCHAR);</em>
<a name="98" href="#98">98</a>  <em class="jxr_javadoccomment"> * dbqc.put(&amp;quot;pippo&amp;quot;, Types.VARCHAR);</em>
<a name="99" href="#99">99</a>  <em class="jxr_javadoccomment"> * try {</em>
<a name="100" href="#100">100</a> <em class="jxr_javadoccomment"> *     dbqc.fillQuery();</em>
<a name="101" href="#101">101</a> <em class="jxr_javadoccomment"> *     int num = dbqc.executeUpdate();</em>
<a name="102" href="#102">102</a> <em class="jxr_javadoccomment"> *     </em>
<a name="103" href="#103">103</a> <em class="jxr_javadoccomment"> *     dbqc.commit();   // NON DIMENTICARSI DI FARE LA COMMIT!!</em>
<a name="104" href="#104">104</a> <em class="jxr_javadoccomment"> *     </em>
<a name="105" href="#105">105</a> <em class="jxr_javadoccomment"> * } catch (SQLException e) {</em>
<a name="106" href="#106">106</a> <em class="jxr_javadoccomment"> *     e.printStackTrace();</em>
<a name="107" href="#107">107</a> <em class="jxr_javadoccomment"> *     System.err.println(e.getMessage());</em>
<a name="108" href="#108">108</a> <em class="jxr_javadoccomment"> *     dbqc.closeAll();</em>
<a name="109" href="#109">109</a> <em class="jxr_javadoccomment"> * } finally {</em>
<a name="110" href="#110">110</a> <em class="jxr_javadoccomment"> *     dbqc.closeAll();  </em>
<a name="111" href="#111">111</a> <em class="jxr_javadoccomment"> * }</em>
<a name="112" href="#112">112</a> <em class="jxr_javadoccomment"> * &lt;/pre&gt;</em>
<a name="113" href="#113">113</a> <em class="jxr_javadoccomment"> * </em>
<a name="114" href="#114">114</a> <em class="jxr_javadoccomment"> * @author Marco Speranza</em>
<a name="115" href="#115">115</a> <em class="jxr_javadoccomment"> */</em>
<a name="116" href="#116">116</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../org/commons/database/util/jquerycreator/DataBaseQueryCreator.html">DataBaseQueryCreator</a> implements <a href="../../../../../org/commons/database/util/jquerycreator/IDataBaseQueryCreator.html">IDataBaseQueryCreator</a> {
<a name="117" href="#117">117</a> 
<a name="118" href="#118">118</a>     <em class="jxr_javadoccomment">/**</em><em class="jxr_javadoccomment"> The Constant logger. */</em>
<a name="119" href="#119">119</a>     <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> Log logger = LogFactory
<a name="120" href="#120">120</a> 	    .getLog(DataBaseQueryCreator.<strong class="jxr_keyword">class</strong>);
<a name="121" href="#121">121</a> 
<a name="122" href="#122">122</a>     <em class="jxr_javadoccomment">/**</em><em class="jxr_javadoccomment"> The Constant serialVersionUID. */</em>
<a name="123" href="#123">123</a>     <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">long</strong> serialVersionUID = 8999935174846078473L;
<a name="124" href="#124">124</a> 
<a name="125" href="#125">125</a>     <em class="jxr_javadoccomment">/**</em><em class="jxr_javadoccomment"> The autogenerated key. */</em>
<a name="126" href="#126">126</a>     <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">int</strong> autogeneratedKey = Statement.NO_GENERATED_KEYS;
<a name="127" href="#127">127</a> 
<a name="128" href="#128">128</a>     <em class="jxr_javadoccomment">/**</em><em class="jxr_javadoccomment"> The connection. */</em>
<a name="129" href="#129">129</a>     <strong class="jxr_keyword">private</strong> Connection connection;
<a name="130" href="#130">130</a> 
<a name="131" href="#131">131</a>     <em class="jxr_javadoccomment">/**</em><em class="jxr_javadoccomment"> The datasource manager. */</em>
<a name="132" href="#132">132</a>     <strong class="jxr_keyword">private</strong> <a href="../../../../../org/commons/database/util/jquerycreator/IDatasourceManager.html">IDatasourceManager</a> datasourceManager;
<a name="133" href="#133">133</a> 
<a name="134" href="#134">134</a>     <em class="jxr_javadoccomment">/**</em><em class="jxr_javadoccomment"> The maps. */</em>
<a name="135" href="#135">135</a>     <strong class="jxr_keyword">private</strong> Map&lt;String, DataBaseQueryCreatorBean&gt; maps;
<a name="136" href="#136">136</a> 
<a name="137" href="#137">137</a>     <em class="jxr_javadoccomment">/**</em><em class="jxr_javadoccomment"> The position. */</em>
<a name="138" href="#138">138</a>     <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">int</strong> position = 0;
<a name="139" href="#139">139</a> 
<a name="140" href="#140">140</a>     <em class="jxr_javadoccomment">/**</em><em class="jxr_javadoccomment"> The result set. */</em>
<a name="141" href="#141">141</a>     <strong class="jxr_keyword">private</strong> ResultSet resultSet;
<a name="142" href="#142">142</a> 
<a name="143" href="#143">143</a>     <em class="jxr_javadoccomment">/**</em><em class="jxr_javadoccomment"> The sql. */</em>
<a name="144" href="#144">144</a>     <strong class="jxr_keyword">private</strong> String sql;
<a name="145" href="#145">145</a> 
<a name="146" href="#146">146</a>     <em class="jxr_javadoccomment">/**</em><em class="jxr_javadoccomment"> The statement. */</em>
<a name="147" href="#147">147</a>     <strong class="jxr_keyword">private</strong> PreparedStatement statement;
<a name="148" href="#148">148</a> 
<a name="149" href="#149">149</a>     <em class="jxr_javadoccomment">/**</em>
<a name="150" href="#150">150</a> <em class="jxr_javadoccomment">     * Instantiates a new data base query creator.</em>
<a name="151" href="#151">151</a> <em class="jxr_javadoccomment">     */</em>
<a name="152" href="#152">152</a>     <strong class="jxr_keyword">public</strong> <a href="../../../../../org/commons/database/util/jquerycreator/DataBaseQueryCreator.html">DataBaseQueryCreator</a>() {
<a name="153" href="#153">153</a> 	<strong class="jxr_keyword">this</strong>(Statement.NO_GENERATED_KEYS);
<a name="154" href="#154">154</a>     }
<a name="155" href="#155">155</a> 
<a name="156" href="#156">156</a>     <em class="jxr_javadoccomment">/**</em>
<a name="157" href="#157">157</a> <em class="jxr_javadoccomment">     * Instantiates a new data base query creator.</em>
<a name="158" href="#158">158</a> <em class="jxr_javadoccomment">     * </em>
<a name="159" href="#159">159</a> <em class="jxr_javadoccomment">     * @param autogeneratedKey</em>
<a name="160" href="#160">160</a> <em class="jxr_javadoccomment">     *            the autogenerated key</em>
<a name="161" href="#161">161</a> <em class="jxr_javadoccomment">     */</em>
<a name="162" href="#162">162</a>     <strong class="jxr_keyword">public</strong> <a href="../../../../../org/commons/database/util/jquerycreator/DataBaseQueryCreator.html">DataBaseQueryCreator</a>(<strong class="jxr_keyword">int</strong> autogeneratedKey) {
<a name="163" href="#163">163</a> 	maps = <strong class="jxr_keyword">new</strong> HashMap&lt;String, DataBaseQueryCreatorBean&gt;(1);
<a name="164" href="#164">164</a> 	setAutogeneratedKey(autogeneratedKey);
<a name="165" href="#165">165</a>     }
<a name="166" href="#166">166</a> 
<a name="167" href="#167">167</a>     <em class="jxr_comment">/*</em>
<a name="168" href="#168">168</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="169" href="#169">169</a> <em class="jxr_comment">     * </em>
<a name="170" href="#170">170</a> <em class="jxr_comment">     * @see</em>
<a name="171" href="#171">171</a> <em class="jxr_comment">     * org.commons.database.util.jquerycreator.IDataBaseQueryCreator#commit()</em>
<a name="172" href="#172">172</a> <em class="jxr_comment">     */</em>
<a name="173" href="#173">173</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> commit() <strong class="jxr_keyword">throws</strong> SQLException {
<a name="174" href="#174">174</a> 	<strong class="jxr_keyword">if</strong> (connection != <strong class="jxr_keyword">null</strong> &amp;&amp; connection.isClosed() == false) {
<a name="175" href="#175">175</a> 	    connection.commit();
<a name="176" href="#176">176</a> 	    logger.debug(<span class="jxr_string">"commit executed"</span>);
<a name="177" href="#177">177</a> 	}
<a name="178" href="#178">178</a>     }
<a name="179" href="#179">179</a> 
<a name="180" href="#180">180</a>     <em class="jxr_javadoccomment">/**</em>
<a name="181" href="#181">181</a> <em class="jxr_javadoccomment">     * Esegue la rollback sulla connessione.</em>
<a name="182" href="#182">182</a> <em class="jxr_javadoccomment">     * </em>
<a name="183" href="#183">183</a> <em class="jxr_javadoccomment">     * in caso di SQLException non viene propagata l'eccezione.</em>
<a name="184" href="#184">184</a> <em class="jxr_javadoccomment">     * </em>
<a name="185" href="#185">185</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
<a name="186" href="#186">186</a> <em class="jxr_javadoccomment">     */</em>
<a name="187" href="#187">187</a>     <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> rollback() <strong class="jxr_keyword">throws</strong> SQLException {
<a name="188" href="#188">188</a> 	<strong class="jxr_keyword">if</strong> (connection != <strong class="jxr_keyword">null</strong> &amp;&amp; connection.isClosed() == false) {
<a name="189" href="#189">189</a> 	    connection.rollback();
<a name="190" href="#190">190</a> 	    logger.debug(<span class="jxr_string">"rollback executed"</span>);
<a name="191" href="#191">191</a> 	}
<a name="192" href="#192">192</a>     }
<a name="193" href="#193">193</a> 
<a name="194" href="#194">194</a>     <em class="jxr_javadoccomment">/**</em>
<a name="195" href="#195">195</a> <em class="jxr_javadoccomment">     * Rimuove tutti gli elemti dalla mappa.</em>
<a name="196" href="#196">196</a> <em class="jxr_javadoccomment">     */</em>
<a name="197" href="#197">197</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> clear() {
<a name="198" href="#198">198</a> 	maps.clear();
<a name="199" href="#199">199</a> 	position = 0;
<a name="200" href="#200">200</a> 	sql = <strong class="jxr_keyword">null</strong>;
<a name="201" href="#201">201</a>     }
<a name="202" href="#202">202</a> 
<a name="203" href="#203">203</a>     <em class="jxr_comment">/*</em>
<a name="204" href="#204">204</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="205" href="#205">205</a> <em class="jxr_comment">     * </em>
<a name="206" href="#206">206</a> <em class="jxr_comment">     * @see</em>
<a name="207" href="#207">207</a> <em class="jxr_comment">     * org.commons.database.util.jquerycreator.IDataBaseQueryCreator#closeAll()</em>
<a name="208" href="#208">208</a> <em class="jxr_comment">     */</em>
<a name="209" href="#209">209</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> closeAll() <strong class="jxr_keyword">throws</strong> SQLException {
<a name="210" href="#210">210</a> 	logger.debug(<span class="jxr_string">"Closing All.."</span>);
<a name="211" href="#211">211</a> 
<a name="212" href="#212">212</a> 	JdbcUtils.close(resultSet, statement);
<a name="213" href="#213">213</a> 	datasourceManager.releaseConnection(connection);
<a name="214" href="#214">214</a> 	resultSet = <strong class="jxr_keyword">null</strong>;
<a name="215" href="#215">215</a> 	statement = <strong class="jxr_keyword">null</strong>;
<a name="216" href="#216">216</a> 	connection = <strong class="jxr_keyword">null</strong>;
<a name="217" href="#217">217</a> 	logger.debug(<span class="jxr_string">"...done!."</span>);
<a name="218" href="#218">218</a> 
<a name="219" href="#219">219</a>     }
<a name="220" href="#220">220</a> 
<a name="221" href="#221">221</a>     <em class="jxr_comment">/*</em>
<a name="222" href="#222">222</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="223" href="#223">223</a> <em class="jxr_comment">     * </em>
<a name="224" href="#224">224</a> <em class="jxr_comment">     * @seeorg.commons.database.util.jquerycreator.IDataBaseQueryCreator#</em>
<a name="225" href="#225">225</a> <em class="jxr_comment">     * closeAllWithoutConnection()</em>
<a name="226" href="#226">226</a> <em class="jxr_comment">     */</em>
<a name="227" href="#227">227</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> closeAllWithoutConnection() <strong class="jxr_keyword">throws</strong> SQLException {
<a name="228" href="#228">228</a> 	JdbcUtils.close(resultSet, statement);
<a name="229" href="#229">229</a> 	resultSet = <strong class="jxr_keyword">null</strong>;
<a name="230" href="#230">230</a> 	statement = <strong class="jxr_keyword">null</strong>;
<a name="231" href="#231">231</a>     }
<a name="232" href="#232">232</a> 
<a name="233" href="#233">233</a>     <em class="jxr_comment">/*</em>
<a name="234" href="#234">234</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="235" href="#235">235</a> <em class="jxr_comment">     * </em>
<a name="236" href="#236">236</a> <em class="jxr_comment">     * @see</em>
<a name="237" href="#237">237</a> <em class="jxr_comment">     * org.commons.database.util.jquerycreator.IDataBaseQueryCreator#executeQuery</em>
<a name="238" href="#238">238</a> <em class="jxr_comment">     * ()</em>
<a name="239" href="#239">239</a> <em class="jxr_comment">     */</em>
<a name="240" href="#240">240</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> executeQuery() <strong class="jxr_keyword">throws</strong> SQLException {
<a name="241" href="#241">241</a> 	<strong class="jxr_keyword">try</strong> {
<a name="242" href="#242">242</a> 	    resultSet = statement.executeQuery();
<a name="243" href="#243">243</a> 	} <strong class="jxr_keyword">catch</strong> (SQLException e) {
<a name="244" href="#244">244</a> 	    logger.error(e.getMessage(), e);
<a name="245" href="#245">245</a> 	    rollback();
<a name="246" href="#246">246</a> 	    closeAll();
<a name="247" href="#247">247</a> 
<a name="248" href="#248">248</a> 	    <strong class="jxr_keyword">throw</strong> e;
<a name="249" href="#249">249</a> 	}
<a name="250" href="#250">250</a>     }
<a name="251" href="#251">251</a> 
<a name="252" href="#252">252</a>     <em class="jxr_comment">/*</em>
<a name="253" href="#253">253</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="254" href="#254">254</a> <em class="jxr_comment">     * </em>
<a name="255" href="#255">255</a> <em class="jxr_comment">     * @see</em>
<a name="256" href="#256">256</a> <em class="jxr_comment">     * org.commons.database.util.jquerycreator.IDataBaseQueryCreator#executeUpdate</em>
<a name="257" href="#257">257</a> <em class="jxr_comment">     * ()</em>
<a name="258" href="#258">258</a> <em class="jxr_comment">     */</em>
<a name="259" href="#259">259</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> executeUpdate() <strong class="jxr_keyword">throws</strong> SQLException {
<a name="260" href="#260">260</a> 	<strong class="jxr_keyword">try</strong> {
<a name="261" href="#261">261</a> 	    <strong class="jxr_keyword">int</strong> rows = statement.executeUpdate();
<a name="262" href="#262">262</a> 	    <strong class="jxr_keyword">return</strong> rows;
<a name="263" href="#263">263</a> 	} <strong class="jxr_keyword">catch</strong> (SQLException e) {
<a name="264" href="#264">264</a> 	    logger.error(e.getMessage(), e);
<a name="265" href="#265">265</a> 	    rollback();
<a name="266" href="#266">266</a> 	    closeAll();
<a name="267" href="#267">267</a> 	    <strong class="jxr_keyword">throw</strong> e;
<a name="268" href="#268">268</a> 	}
<a name="269" href="#269">269</a> 
<a name="270" href="#270">270</a>     }
<a name="271" href="#271">271</a> 
<a name="272" href="#272">272</a>     <em class="jxr_comment">/*</em>
<a name="273" href="#273">273</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="274" href="#274">274</a> <em class="jxr_comment">     * </em>
<a name="275" href="#275">275</a> <em class="jxr_comment">     * @see</em>
<a name="276" href="#276">276</a> <em class="jxr_comment">     * org.commons.database.util.jquerycreator.IDataBaseQueryCreator#executeUpdate</em>
<a name="277" href="#277">277</a> <em class="jxr_comment">     * (int[])</em>
<a name="278" href="#278">278</a> <em class="jxr_comment">     */</em>
<a name="279" href="#279">279</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> executeUpdate(<strong class="jxr_keyword">int</strong>[] columnIndex) <strong class="jxr_keyword">throws</strong> SQLException {
<a name="280" href="#280">280</a> 	<strong class="jxr_keyword">try</strong> {
<a name="281" href="#281">281</a> 	    <strong class="jxr_keyword">int</strong> num = statement.executeUpdate(getSql(), columnIndex);
<a name="282" href="#282">282</a> 	    resultSet = statement.getGeneratedKeys();
<a name="283" href="#283">283</a> 	    <strong class="jxr_keyword">return</strong> num;
<a name="284" href="#284">284</a> 	} <strong class="jxr_keyword">catch</strong> (SQLException e) {
<a name="285" href="#285">285</a> 	    logger.error(e.getMessage(), e);
<a name="286" href="#286">286</a> 	    rollback();
<a name="287" href="#287">287</a> 	    closeAll();
<a name="288" href="#288">288</a> 	    <strong class="jxr_keyword">throw</strong> e;
<a name="289" href="#289">289</a> 	}
<a name="290" href="#290">290</a>     }
<a name="291" href="#291">291</a> 
<a name="292" href="#292">292</a>     <em class="jxr_comment">/*</em>
<a name="293" href="#293">293</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="294" href="#294">294</a> <em class="jxr_comment">     * </em>
<a name="295" href="#295">295</a> <em class="jxr_comment">     * @see</em>
<a name="296" href="#296">296</a> <em class="jxr_comment">     * org.commons.database.util.jquerycreator.IDataBaseQueryCreator#fillQuery()</em>
<a name="297" href="#297">297</a> <em class="jxr_comment">     */</em>
<a name="298" href="#298">298</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> fillQuery() <strong class="jxr_keyword">throws</strong> SQLException {
<a name="299" href="#299">299</a> 	<strong class="jxr_keyword">try</strong> {
<a name="300" href="#300">300</a> 	    <strong class="jxr_keyword">if</strong> (statement == <strong class="jxr_keyword">null</strong>) {
<a name="301" href="#301">301</a> 		makePreparedStatement();
<a name="302" href="#302">302</a> 	    }
<a name="303" href="#303">303</a> 	    fillQuery(statement);
<a name="304" href="#304">304</a> 	} <strong class="jxr_keyword">catch</strong> (SQLException e) {
<a name="305" href="#305">305</a> 	    logger.error(e.getMessage(), e);
<a name="306" href="#306">306</a> 	    rollback();
<a name="307" href="#307">307</a> 	    closeAll();
<a name="308" href="#308">308</a> 	    <strong class="jxr_keyword">throw</strong> e;
<a name="309" href="#309">309</a> 	}
<a name="310" href="#310">310</a> 
<a name="311" href="#311">311</a>     }
<a name="312" href="#312">312</a> 
<a name="313" href="#313">313</a>     <em class="jxr_javadoccomment">/**</em>
<a name="314" href="#314">314</a> <em class="jxr_javadoccomment">     * Sostituisce i '?' con i valori associati.</em>
<a name="315" href="#315">315</a> <em class="jxr_javadoccomment">     * </em>
<a name="316" href="#316">316</a> <em class="jxr_javadoccomment">     * @param stmt</em>
<a name="317" href="#317">317</a> <em class="jxr_javadoccomment">     *            N.B. &lt;code&gt;stmt&lt;/code&gt; deve essere la stessa instanza della</em>
<a name="318" href="#318">318</a> <em class="jxr_javadoccomment">     *            variabile interna &lt;code&gt;statement&lt;/code&gt; Utilizzare il meetodo</em>
<a name="319" href="#319">319</a> <em class="jxr_javadoccomment">     *            &lt;code&gt;makePreparedStatement&lt;/code&gt; per creare una instanza</em>
<a name="320" href="#320">320</a> <em class="jxr_javadoccomment">     *            dell'oggetto stmt.</em>
<a name="321" href="#321">321</a> <em class="jxr_javadoccomment">     * </em>
<a name="322" href="#322">322</a> <em class="jxr_javadoccomment">     * @return the prepared statement</em>
<a name="323" href="#323">323</a> <em class="jxr_javadoccomment">     * </em>
<a name="324" href="#324">324</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
<a name="325" href="#325">325</a> <em class="jxr_javadoccomment">     *             in caso di errore chude le risorse al database, compreso il</em>
<a name="326" href="#326">326</a> <em class="jxr_javadoccomment">     *             preparestatement in input</em>
<a name="327" href="#327">327</a> <em class="jxr_javadoccomment">     */</em>
<a name="328" href="#328">328</a>     <strong class="jxr_keyword">public</strong> PreparedStatement fillQuery(<strong class="jxr_keyword">final</strong> PreparedStatement stmt)
<a name="329" href="#329">329</a> 	    <strong class="jxr_keyword">throws</strong> SQLException {
<a name="330" href="#330">330</a> 	<strong class="jxr_keyword">try</strong> {
<a name="331" href="#331">331</a> 	    <strong class="jxr_keyword">if</strong> (stmt != statement) {
<a name="332" href="#332">332</a> 		<strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> IllegalArgumentException(
<a name="333" href="#333">333</a> 			<span class="jxr_string">"the argument must be the same object of statement field."</span>
<a name="334" href="#334">334</a> 				+ <span class="jxr_string">" Use makePreparedStatement() or "</span>
<a name="335" href="#335">335</a> 				+ <span class="jxr_string">" makePreparedStatement(String)  to create this object."</span>);
<a name="336" href="#336">336</a> 	    }
<a name="337" href="#337">337</a> 
<a name="338" href="#338">338</a> 	    <strong class="jxr_keyword">if</strong> (!isAllFilled())
<a name="339" href="#339">339</a> 		<strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> IllegalArgumentException(<span class="jxr_string">"All '?' must be filled."</span>);
<a name="340" href="#340">340</a> 
<a name="341" href="#341">341</a> 	    <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; maps.size(); i++) {
<a name="342" href="#342">342</a> 		DataBaseQueryCreatorBean bean = maps.get(<span class="jxr_string">""</span> + (i + 1));
<a name="343" href="#343">343</a> 		fillValue(stmt, bean);
<a name="344" href="#344">344</a> 	    }
<a name="345" href="#345">345</a> 	    <strong class="jxr_keyword">return</strong> stmt;
<a name="346" href="#346">346</a> 	} <strong class="jxr_keyword">catch</strong> (SQLException e) {
<a name="347" href="#347">347</a> 	    rollback();
<a name="348" href="#348">348</a> 	    closeAll();
<a name="349" href="#349">349</a> 	    <strong class="jxr_keyword">throw</strong> e;
<a name="350" href="#350">350</a> 	}
<a name="351" href="#351">351</a>     }
<a name="352" href="#352">352</a> 
<a name="353" href="#353">353</a>     <em class="jxr_comment">/*</em>
<a name="354" href="#354">354</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="355" href="#355">355</a> <em class="jxr_comment">     * </em>
<a name="356" href="#356">356</a> <em class="jxr_comment">     * @see</em>
<a name="357" href="#357">357</a> <em class="jxr_comment">     * org.commons.database.util.jquerycreator.IDataBaseQueryCreator#fillQuery</em>
<a name="358" href="#358">358</a> <em class="jxr_comment">     * (java.lang.String)</em>
<a name="359" href="#359">359</a> <em class="jxr_comment">     */</em>
<a name="360" href="#360">360</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> fillQuery(<strong class="jxr_keyword">final</strong> String sql) <strong class="jxr_keyword">throws</strong> SQLException {
<a name="361" href="#361">361</a> 	<strong class="jxr_keyword">try</strong> {
<a name="362" href="#362">362</a> 	    <strong class="jxr_keyword">if</strong> (statement == <strong class="jxr_keyword">null</strong>) {
<a name="363" href="#363">363</a> 		makePreparedStatement(sql);
<a name="364" href="#364">364</a> 	    } <strong class="jxr_keyword">else</strong> {
<a name="365" href="#365">365</a> 		setSql(sql);
<a name="366" href="#366">366</a> 	    }
<a name="367" href="#367">367</a> 
<a name="368" href="#368">368</a> 	    fillQuery(statement);
<a name="369" href="#369">369</a> 	} <strong class="jxr_keyword">catch</strong> (SQLException e) {
<a name="370" href="#370">370</a> 	    logger.error(e.getMessage(), e);
<a name="371" href="#371">371</a> 	    rollback();
<a name="372" href="#372">372</a> 	    closeAll();
<a name="373" href="#373">373</a> 	    <strong class="jxr_keyword">throw</strong> e;
<a name="374" href="#374">374</a> 	}
<a name="375" href="#375">375</a> 
<a name="376" href="#376">376</a>     }
<a name="377" href="#377">377</a> 
<a name="378" href="#378">378</a>     <em class="jxr_javadoccomment">/**</em>
<a name="379" href="#379">379</a> <em class="jxr_javadoccomment">     * Tornala query sql in formato testo sostituendo i '?' con i valori</em>
<a name="380" href="#380">380</a> <em class="jxr_javadoccomment">     * inseriti.</em>
<a name="381" href="#381">381</a> <em class="jxr_javadoccomment">     * </em>
<a name="382" href="#382">382</a> <em class="jxr_javadoccomment">     * @return the filled query</em>
<a name="383" href="#383">383</a> <em class="jxr_javadoccomment">     */</em>
<a name="384" href="#384">384</a>     <strong class="jxr_keyword">public</strong> String getFilledQuery() {
<a name="385" href="#385">385</a> 	String sql = getSql();
<a name="386" href="#386">386</a> 	<strong class="jxr_keyword">if</strong> (sql == <strong class="jxr_keyword">null</strong>)
<a name="387" href="#387">387</a> 	    <strong class="jxr_keyword">return</strong> <span class="jxr_string">""</span>;
<a name="388" href="#388">388</a> 
<a name="389" href="#389">389</a> 	Pattern myPattern = Pattern.compile(<span class="jxr_string">"&#92;&#92;?"</span>);
<a name="390" href="#390">390</a> 
<a name="391" href="#391">391</a> 	Matcher myMatcher = myPattern.matcher(sql);
<a name="392" href="#392">392</a> 
<a name="393" href="#393">393</a> 	<strong class="jxr_keyword">int</strong> index = 0;
<a name="394" href="#394">394</a> 	StringBuffer buf = <strong class="jxr_keyword">new</strong> StringBuffer();
<a name="395" href="#395">395</a> 	<strong class="jxr_keyword">while</strong> ((myMatcher.find())) {
<a name="396" href="#396">396</a> 
<a name="397" href="#397">397</a> 	    DataBaseQueryCreatorBean bean = maps.get(<span class="jxr_string">""</span> + (index + 1));
<a name="398" href="#398">398</a> 
<a name="399" href="#399">399</a> 	    <strong class="jxr_keyword">if</strong> (bean != <strong class="jxr_keyword">null</strong>) {
<a name="400" href="#400">400</a> 
<a name="401" href="#401">401</a> 		<strong class="jxr_keyword">switch</strong> (bean.getType()) {
<a name="402" href="#402">402</a> 		<strong class="jxr_keyword">case</strong> Types.VARCHAR:
<a name="403" href="#403">403</a> 		    myMatcher.appendReplacement(buf, <span class="jxr_string">"'"</span> + bean.getValue()
<a name="404" href="#404">404</a> 			    + <span class="jxr_string">"'"</span>);
<a name="405" href="#405">405</a> 		    <strong class="jxr_keyword">break</strong>;
<a name="406" href="#406">406</a> 		<strong class="jxr_keyword">case</strong> Types.INTEGER:
<a name="407" href="#407">407</a> 		    myMatcher.appendReplacement(buf, <span class="jxr_string">""</span> + bean.getValue());
<a name="408" href="#408">408</a> 		    <strong class="jxr_keyword">break</strong>;
<a name="409" href="#409">409</a> 		<strong class="jxr_keyword">case</strong> Types.TIMESTAMP:
<a name="410" href="#410">410</a> 		    Timestamp t = (Timestamp) bean.getValue();
<a name="411" href="#411">411</a> 		    String repStr = <span class="jxr_string">"TO_DATE('"</span>
<a name="412" href="#412">412</a> 			    + DateConv.toString(t.getTime())
<a name="413" href="#413">413</a> 			    + <span class="jxr_string">"','yyyy-mm-dd hh24:mi:ss')"</span>;
<a name="414" href="#414">414</a> 		    myMatcher.appendReplacement(buf, repStr);
<a name="415" href="#415">415</a> 		    <strong class="jxr_keyword">break</strong>;
<a name="416" href="#416">416</a> 		<strong class="jxr_keyword">case</strong> Types.NULL:
<a name="417" href="#417">417</a> 		    myMatcher.appendReplacement(buf, <span class="jxr_string">"null"</span>);
<a name="418" href="#418">418</a> 		    <strong class="jxr_keyword">break</strong>;
<a name="419" href="#419">419</a> 		<strong class="jxr_keyword">case</strong> Types.CLOB:
<a name="420" href="#420">420</a> 		    myMatcher.appendReplacement(buf, <span class="jxr_string">"'"</span> + bean.getValue()
<a name="421" href="#421">421</a> 			    + <span class="jxr_string">"'"</span>);
<a name="422" href="#422">422</a> 		    <strong class="jxr_keyword">break</strong>;
<a name="423" href="#423">423</a> 		<strong class="jxr_keyword">case</strong> Types.BLOB:
<a name="424" href="#424">424</a> 		    myMatcher.appendReplacement(buf, <span class="jxr_string">"'"</span> + bean.getValue()
<a name="425" href="#425">425</a> 			    + <span class="jxr_string">"'"</span>);
<a name="426" href="#426">426</a> 		    <strong class="jxr_keyword">break</strong>;
<a name="427" href="#427">427</a> 		<strong class="jxr_keyword">default</strong>:
<a name="428" href="#428">428</a> 		    myMatcher.appendReplacement(buf, <span class="jxr_string">"'"</span> + bean.getValue()
<a name="429" href="#429">429</a> 			    + <span class="jxr_string">"'"</span>);
<a name="430" href="#430">430</a> 		}
<a name="431" href="#431">431</a> 
<a name="432" href="#432">432</a> 	    } <strong class="jxr_keyword">else</strong> {
<a name="433" href="#433">433</a> 		myMatcher.appendReplacement(buf, <span class="jxr_string">"?"</span>);
<a name="434" href="#434">434</a> 	    }
<a name="435" href="#435">435</a> 	    index++;
<a name="436" href="#436">436</a> 	}
<a name="437" href="#437">437</a> 	myMatcher.appendTail(buf);
<a name="438" href="#438">438</a> 	String result = buf.toString();
<a name="439" href="#439">439</a> 	<strong class="jxr_keyword">return</strong> result;
<a name="440" href="#440">440</a>     }
<a name="441" href="#441">441</a> 
<a name="442" href="#442">442</a>     <em class="jxr_javadoccomment">/**</em>
<a name="443" href="#443">443</a> <em class="jxr_javadoccomment">     * Gets the position.</em>
<a name="444" href="#444">444</a> <em class="jxr_javadoccomment">     * </em>
<a name="445" href="#445">445</a> <em class="jxr_javadoccomment">     * @return the position</em>
<a name="446" href="#446">446</a> <em class="jxr_javadoccomment">     */</em>
<a name="447" href="#447">447</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> getPosition() {
<a name="448" href="#448">448</a> 	<strong class="jxr_keyword">return</strong> position;
<a name="449" href="#449">449</a>     }
<a name="450" href="#450">450</a> 
<a name="451" href="#451">451</a>     <em class="jxr_comment">/*</em>
<a name="452" href="#452">452</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="453" href="#453">453</a> <em class="jxr_comment">     * </em>
<a name="454" href="#454">454</a> <em class="jxr_comment">     * @see</em>
<a name="455" href="#455">455</a> <em class="jxr_comment">     * org.commons.database.util.jquerycreator.IDataBaseQueryCreator#getResultSet</em>
<a name="456" href="#456">456</a> <em class="jxr_comment">     * ()</em>
<a name="457" href="#457">457</a> <em class="jxr_comment">     */</em>
<a name="458" href="#458">458</a>     <strong class="jxr_keyword">public</strong> ResultSet getResultSet() {
<a name="459" href="#459">459</a> 	<strong class="jxr_keyword">return</strong> resultSet;
<a name="460" href="#460">460</a>     }
<a name="461" href="#461">461</a> 
<a name="462" href="#462">462</a>     <em class="jxr_comment">/*</em>
<a name="463" href="#463">463</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="464" href="#464">464</a> <em class="jxr_comment">     * </em>
<a name="465" href="#465">465</a> <em class="jxr_comment">     * @see</em>
<a name="466" href="#466">466</a> <em class="jxr_comment">     * org.commons.database.util.jquerycreator.IDataBaseQueryCreator#getSql()</em>
<a name="467" href="#467">467</a> <em class="jxr_comment">     */</em>
<a name="468" href="#468">468</a>     <strong class="jxr_keyword">public</strong> String getSql() {
<a name="469" href="#469">469</a> 	<strong class="jxr_keyword">return</strong> sql;
<a name="470" href="#470">470</a>     }
<a name="471" href="#471">471</a> 
<a name="472" href="#472">472</a>     <em class="jxr_comment">/*</em>
<a name="473" href="#473">473</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="474" href="#474">474</a> <em class="jxr_comment">     * </em>
<a name="475" href="#475">475</a> <em class="jxr_comment">     * @seeorg.commons.database.util.jquerycreator.IDataBaseQueryCreator#</em>
<a name="476" href="#476">476</a> <em class="jxr_comment">     * makePreparedStatement()</em>
<a name="477" href="#477">477</a> <em class="jxr_comment">     */</em>
<a name="478" href="#478">478</a>     <strong class="jxr_keyword">public</strong> PreparedStatement makePreparedStatement() <strong class="jxr_keyword">throws</strong> SQLException {
<a name="479" href="#479">479</a> 
<a name="480" href="#480">480</a> 	<strong class="jxr_keyword">try</strong> {
<a name="481" href="#481">481</a> 	    <strong class="jxr_keyword">if</strong> (getSql() == <strong class="jxr_keyword">null</strong> || getSql().trim().equals(<span class="jxr_string">""</span>)) {
<a name="482" href="#482">482</a> 		<strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> IllegalArgumentException(<span class="jxr_string">"Sql string can't be null. "</span>);
<a name="483" href="#483">483</a> 	    }
<a name="484" href="#484">484</a> 	    makeConnection();
<a name="485" href="#485">485</a> 	    statement = connection.prepareStatement(getSql(), autogeneratedKey);
<a name="486" href="#486">486</a> 	    <strong class="jxr_keyword">return</strong> statement;
<a name="487" href="#487">487</a> 	} <strong class="jxr_keyword">catch</strong> (SQLException e) {
<a name="488" href="#488">488</a> 	    logger.error(e.getMessage(), e);
<a name="489" href="#489">489</a> 	    rollback();
<a name="490" href="#490">490</a> 	    closeAll();
<a name="491" href="#491">491</a> 	    <strong class="jxr_keyword">throw</strong> e;
<a name="492" href="#492">492</a> 	}
<a name="493" href="#493">493</a>     }
<a name="494" href="#494">494</a> 
<a name="495" href="#495">495</a>     <em class="jxr_comment">/*</em>
<a name="496" href="#496">496</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="497" href="#497">497</a> <em class="jxr_comment">     * </em>
<a name="498" href="#498">498</a> <em class="jxr_comment">     * @seeorg.commons.database.util.jquerycreator.IDataBaseQueryCreator#</em>
<a name="499" href="#499">499</a> <em class="jxr_comment">     * makePreparedStatement(java.lang.String)</em>
<a name="500" href="#500">500</a> <em class="jxr_comment">     */</em>
<a name="501" href="#501">501</a>     <strong class="jxr_keyword">public</strong> PreparedStatement makePreparedStatement(<strong class="jxr_keyword">final</strong> String sql)
<a name="502" href="#502">502</a> 	    <strong class="jxr_keyword">throws</strong> SQLException {
<a name="503" href="#503">503</a> 	<strong class="jxr_keyword">try</strong> {
<a name="504" href="#504">504</a> 	    setSql(sql);
<a name="505" href="#505">505</a> 	    <strong class="jxr_keyword">return</strong> makePreparedStatement();
<a name="506" href="#506">506</a> 	} <strong class="jxr_keyword">catch</strong> (SQLException e) {
<a name="507" href="#507">507</a> 	    logger.error(e.getMessage(), e);
<a name="508" href="#508">508</a> 	    rollback();
<a name="509" href="#509">509</a> 	    closeAll();
<a name="510" href="#510">510</a> 	    <strong class="jxr_keyword">throw</strong> e;
<a name="511" href="#511">511</a> 	}
<a name="512" href="#512">512</a>     }
<a name="513" href="#513">513</a> 
<a name="514" href="#514">514</a>     <em class="jxr_javadoccomment">/**</em>
<a name="515" href="#515">515</a> <em class="jxr_javadoccomment">     * Put.</em>
<a name="516" href="#516">516</a> <em class="jxr_javadoccomment">     * </em>
<a name="517" href="#517">517</a> <em class="jxr_javadoccomment">     * @param value</em>
<a name="518" href="#518">518</a> <em class="jxr_javadoccomment">     *            the value</em>
<a name="519" href="#519">519</a> <em class="jxr_javadoccomment">     * @param type</em>
<a name="520" href="#520">520</a> <em class="jxr_javadoccomment">     *            the type</em>
<a name="521" href="#521">521</a> <em class="jxr_javadoccomment">     * </em>
<a name="522" href="#522">522</a> <em class="jxr_javadoccomment">     * @return the object</em>
<a name="523" href="#523">523</a> <em class="jxr_javadoccomment">     * </em>
<a name="524" href="#524">524</a> <em class="jxr_javadoccomment">     * @see IDataBaseQueryCreator.put(Object , int);</em>
<a name="525" href="#525">525</a> <em class="jxr_javadoccomment">     */</em>
<a name="526" href="#526">526</a>     <strong class="jxr_keyword">public</strong> <a href="../../../../../org/commons/database/util/jquerycreator/DataBaseQueryCreatorBean.html">DataBaseQueryCreatorBean</a> put(<strong class="jxr_keyword">final</strong> Object value, <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> type) {
<a name="527" href="#527">527</a> 	DataBaseQueryCreatorBean bean = <strong class="jxr_keyword">new</strong> <a href="../../../../../org/commons/database/util/jquerycreator/DataBaseQueryCreatorBean.html">DataBaseQueryCreatorBean</a>(value,
<a name="528" href="#528">528</a> 		type);
<a name="529" href="#529">529</a> 	bean.setPosition(++position);
<a name="530" href="#530">530</a> 	<strong class="jxr_keyword">return</strong> maps.put(<span class="jxr_string">""</span> + position, bean);
<a name="531" href="#531">531</a>     }
<a name="532" href="#532">532</a> 
<a name="533" href="#533">533</a>     <em class="jxr_comment">/*</em>
<a name="534" href="#534">534</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="535" href="#535">535</a> <em class="jxr_comment">     * </em>
<a name="536" href="#536">536</a> <em class="jxr_comment">     * @seeorg.commons.database.util.jquerycreator.IDataBaseQueryCreator#</em>
<a name="537" href="#537">537</a> <em class="jxr_comment">     * setAutogeneratedKey(int)</em>
<a name="538" href="#538">538</a> <em class="jxr_comment">     */</em>
<a name="539" href="#539">539</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> setAutogeneratedKey(<strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> autogeneratedKey) {
<a name="540" href="#540">540</a> 	<strong class="jxr_keyword">this</strong>.autogeneratedKey = autogeneratedKey;
<a name="541" href="#541">541</a>     }
<a name="542" href="#542">542</a> 
<a name="543" href="#543">543</a>     <em class="jxr_comment">/*</em>
<a name="544" href="#544">544</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="545" href="#545">545</a> <em class="jxr_comment">     * </em>
<a name="546" href="#546">546</a> <em class="jxr_comment">     * @seeorg.commons.database.util.jquerycreator.IDataBaseQueryCreator#</em>
<a name="547" href="#547">547</a> <em class="jxr_comment">     * setDataSourceManager</em>
<a name="548" href="#548">548</a> <em class="jxr_comment">     * (org.commons.database.util.jquerycreator.IDatasourceManager)</em>
<a name="549" href="#549">549</a> <em class="jxr_comment">     */</em>
<a name="550" href="#550">550</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> setDataSourceManager(<strong class="jxr_keyword">final</strong> <a href="../../../../../org/commons/database/util/jquerycreator/IDatasourceManager.html">IDatasourceManager</a> datasourceManager) {
<a name="551" href="#551">551</a> 	<strong class="jxr_keyword">this</strong>.datasourceManager = datasourceManager;
<a name="552" href="#552">552</a>     }
<a name="553" href="#553">553</a> 
<a name="554" href="#554">554</a>     <em class="jxr_comment">/*</em>
<a name="555" href="#555">555</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="556" href="#556">556</a> <em class="jxr_comment">     * </em>
<a name="557" href="#557">557</a> <em class="jxr_comment">     * @see</em>
<a name="558" href="#558">558</a> <em class="jxr_comment">     * org.commons.database.util.jquerycreator.IDataBaseQueryCreator#setSql(</em>
<a name="559" href="#559">559</a> <em class="jxr_comment">     * java.lang.String)</em>
<a name="560" href="#560">560</a> <em class="jxr_comment">     */</em>
<a name="561" href="#561">561</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> setSql(<strong class="jxr_keyword">final</strong> String sql) {
<a name="562" href="#562">562</a> 	<strong class="jxr_keyword">this</strong>.sql = sql;
<a name="563" href="#563">563</a>     }
<a name="564" href="#564">564</a> 
<a name="565" href="#565">565</a>     <em class="jxr_comment">/*</em>
<a name="566" href="#566">566</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="567" href="#567">567</a> <em class="jxr_comment">     * </em>
<a name="568" href="#568">568</a> <em class="jxr_comment">     * @see java.lang.Object#toString()</em>
<a name="569" href="#569">569</a> <em class="jxr_comment">     */</em>
<a name="570" href="#570">570</a>     <strong class="jxr_keyword">public</strong> String toString() {
<a name="571" href="#571">571</a> 	StringBuffer buff = <strong class="jxr_keyword">new</strong> StringBuffer(1);
<a name="572" href="#572">572</a> 	<strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; maps.size(); i++) {
<a name="573" href="#573">573</a> 	    DataBaseQueryCreatorBean bean = ((DataBaseQueryCreatorBean) maps
<a name="574" href="#574">574</a> 		    .get(<span class="jxr_string">""</span> + (i + 1)));
<a name="575" href="#575">575</a> 	    buff.append(<span class="jxr_string">" Position: "</span>);
<a name="576" href="#576">576</a> 	    buff.append(bean.getPosition());
<a name="577" href="#577">577</a> 	    buff.append(<span class="jxr_string">" - Value: "</span>);
<a name="578" href="#578">578</a> 	    buff.append(bean.getValue());
<a name="579" href="#579">579</a> 	    buff.append(<span class="jxr_string">"\n"</span>);
<a name="580" href="#580">580</a> 	}
<a name="581" href="#581">581</a> 	<strong class="jxr_keyword">return</strong> buff.toString();
<a name="582" href="#582">582</a>     }
<a name="583" href="#583">583</a> 
<a name="584" href="#584">584</a>     <em class="jxr_comment">/*</em>
<a name="585" href="#585">585</a> <em class="jxr_comment">     * (non-Javadoc)</em>
<a name="586" href="#586">586</a> <em class="jxr_comment">     * </em>
<a name="587" href="#587">587</a> <em class="jxr_comment">     * @see java.lang.Object#finalize()</em>
<a name="588" href="#588">588</a> <em class="jxr_comment">     */</em>
<a name="589" href="#589">589</a>     <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> finalize() <strong class="jxr_keyword">throws</strong> Throwable {
<a name="590" href="#590">590</a> 	<strong class="jxr_keyword">super</strong>.finalize();
<a name="591" href="#591">591</a> 	closeAll();
<a name="592" href="#592">592</a> 	clear();
<a name="593" href="#593">593</a>     }
<a name="594" href="#594">594</a> 
<a name="595" href="#595">595</a>     <em class="jxr_javadoccomment">/**</em>
<a name="596" href="#596">596</a> <em class="jxr_javadoccomment">     * Fill value.</em>
<a name="597" href="#597">597</a> <em class="jxr_javadoccomment">     * </em>
<a name="598" href="#598">598</a> <em class="jxr_javadoccomment">     * @param stmt</em>
<a name="599" href="#599">599</a> <em class="jxr_javadoccomment">     *            the stmt</em>
<a name="600" href="#600">600</a> <em class="jxr_javadoccomment">     * @param bean</em>
<a name="601" href="#601">601</a> <em class="jxr_javadoccomment">     *            the bean</em>
<a name="602" href="#602">602</a> <em class="jxr_javadoccomment">     * </em>
<a name="603" href="#603">603</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
<a name="604" href="#604">604</a> <em class="jxr_javadoccomment">     *             the SQL exception</em>
<a name="605" href="#605">605</a> <em class="jxr_javadoccomment">     */</em>
<a name="606" href="#606">606</a>     <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">void</strong> fillValue(<strong class="jxr_keyword">final</strong> PreparedStatement stmt,
<a name="607" href="#607">607</a> 	    <strong class="jxr_keyword">final</strong> DataBaseQueryCreatorBean bean) <strong class="jxr_keyword">throws</strong> SQLException {
<a name="608" href="#608">608</a> 	<strong class="jxr_keyword">if</strong> (bean.getType() == Types.CLOB) {
<a name="609" href="#609">609</a> 	    <strong class="jxr_keyword">if</strong> (bean.getValue() instanceof String) {
<a name="610" href="#610">610</a> 		InputStream is = <strong class="jxr_keyword">new</strong> ByteArrayInputStream(((String) bean
<a name="611" href="#611">611</a> 			.getValue()).getBytes());
<a name="612" href="#612">612</a> 		<strong class="jxr_keyword">int</strong> length = ((String) bean.getValue()).length();
<a name="613" href="#613">613</a> 		stmt.setAsciiStream(bean.getPosition(), is, length);
<a name="614" href="#614">614</a> 	    } <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong> (bean.getValue() instanceof Clob) {
<a name="615" href="#615">615</a> 		stmt.setClob(bean.getPosition(), (Clob) bean.getValue());
<a name="616" href="#616">616</a> 	    } <strong class="jxr_keyword">else</strong> {
<a name="617" href="#617">617</a> 		<strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> IllegalArgumentException(
<a name="618" href="#618">618</a> 			<span class="jxr_string">"A Clob type must be a Clob or String instance."</span>);
<a name="619" href="#619">619</a> 	    }
<a name="620" href="#620">620</a> 	} <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong> (bean.getType() == Types.BLOB) {
<a name="621" href="#621">621</a> 	    <strong class="jxr_keyword">if</strong> (bean.getValue() instanceof byte[]) {
<a name="622" href="#622">622</a> 		InputStream is = <strong class="jxr_keyword">new</strong> ByteArrayInputStream((byte[]) bean
<a name="623" href="#623">623</a> 			.getValue());
<a name="624" href="#624">624</a> 		<strong class="jxr_keyword">int</strong> length = ((byte[]) bean.getValue()).length;
<a name="625" href="#625">625</a> 		stmt.setBinaryStream(bean.getPosition(), is, length);
<a name="626" href="#626">626</a> 	    } <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong> (bean.getValue() instanceof Blob) {
<a name="627" href="#627">627</a> 		stmt.setBlob(bean.getPosition(), (Blob) bean.getValue());
<a name="628" href="#628">628</a> 	    } <strong class="jxr_keyword">else</strong> {
<a name="629" href="#629">629</a> 		<strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> IllegalArgumentException(
<a name="630" href="#630">630</a> 			<span class="jxr_string">"A Blob type must be a Blob or byte[] instance."</span>);
<a name="631" href="#631">631</a> 	    }
<a name="632" href="#632">632</a> 	} <strong class="jxr_keyword">else</strong> {
<a name="633" href="#633">633</a> 	    stmt.setObject(bean.getPosition(), bean.getValue(), bean.getType());
<a name="634" href="#634">634</a> 	}
<a name="635" href="#635">635</a>     }
<a name="636" href="#636">636</a> 
<a name="637" href="#637">637</a>     <em class="jxr_javadoccomment">/**</em>
<a name="638" href="#638">638</a> <em class="jxr_javadoccomment">     * Checks if is all filled.</em>
<a name="639" href="#639">639</a> <em class="jxr_javadoccomment">     * </em>
<a name="640" href="#640">640</a> <em class="jxr_javadoccomment">     * @return true, if is all filled</em>
<a name="641" href="#641">641</a> <em class="jxr_javadoccomment">     */</em>
<a name="642" href="#642">642</a>     <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">boolean</strong> isAllFilled() {
<a name="643" href="#643">643</a> 	String sql = getSql();
<a name="644" href="#644">644</a> 	<strong class="jxr_keyword">if</strong> (sql == <strong class="jxr_keyword">null</strong>)
<a name="645" href="#645">645</a> 	    <strong class="jxr_keyword">return</strong> false;
<a name="646" href="#646">646</a> 
<a name="647" href="#647">647</a> 	Pattern myPattern = Pattern.compile(<span class="jxr_string">"&#92;&#92;?"</span>);
<a name="648" href="#648">648</a> 
<a name="649" href="#649">649</a> 	Matcher myMatcher = myPattern.matcher(sql);
<a name="650" href="#650">650</a> 
<a name="651" href="#651">651</a> 	<strong class="jxr_keyword">int</strong> index = 0;
<a name="652" href="#652">652</a> 	<strong class="jxr_keyword">while</strong> ((myMatcher.find())) {
<a name="653" href="#653">653</a> 	    index++;
<a name="654" href="#654">654</a> 	}
<a name="655" href="#655">655</a> 
<a name="656" href="#656">656</a> 	<strong class="jxr_keyword">return</strong> (maps.size() == index);
<a name="657" href="#657">657</a>     }
<a name="658" href="#658">658</a> 
<a name="659" href="#659">659</a>     <em class="jxr_javadoccomment">/**</em>
<a name="660" href="#660">660</a> <em class="jxr_javadoccomment">     * Make connection.</em>
<a name="661" href="#661">661</a> <em class="jxr_javadoccomment">     * </em>
<a name="662" href="#662">662</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
<a name="663" href="#663">663</a> <em class="jxr_javadoccomment">     *             the SQL exception</em>
<a name="664" href="#664">664</a> <em class="jxr_javadoccomment">     */</em>
<a name="665" href="#665">665</a>     <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">void</strong> makeConnection() <strong class="jxr_keyword">throws</strong> SQLException {
<a name="666" href="#666">666</a> 	<strong class="jxr_keyword">if</strong> (datasourceManager == <strong class="jxr_keyword">null</strong>)
<a name="667" href="#667">667</a> 	    <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> NullPointerException(<span class="jxr_string">"databasesourceManager must be set."</span>);
<a name="668" href="#668">668</a> 	<strong class="jxr_keyword">if</strong> (<strong class="jxr_keyword">this</strong>.connection == <strong class="jxr_keyword">null</strong> || <strong class="jxr_keyword">this</strong>.connection.isClosed()) {
<a name="669" href="#669">669</a> 	    connection = datasourceManager.getConnection();
<a name="670" href="#670">670</a> 	}
<a name="671" href="#671">671</a>     }
<a name="672" href="#672">672</a> 
<a name="673" href="#673">673</a> }
</pre>
<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
</html>

